USE [IstoreInternet]
GO

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO




CREATE PROCEDURE [dbo].[InsertCustomer]
	@organisationOrPerson bit,
	@organisationName nvarchar(100),
	@gender nvarchar(1),
	@firstName nvarchar(100),
	@middleName nvarchar(100),
	@lastName nvarchar(100),
	@emailPost nvarchar(100),
	@phoneNumber nvarchar(25),
	@mobilePhoneNumber nvarchar(25),
	@dateOfBirth date,
	@postIndex nvarchar(10)
AS
BEGIN
	SET NOCOUNT ON;

    INSERT INTO dbo.Customer (organisationOrPerson, organisationName, gender, firstName, middleName, lastName, emailPost, phoneNumber, mobilePhoneNumber, dateOfBirth, postIndex)
    VALUES (@organisationOrPerson, @organisationName, @gender, @firstName, @middleName, @lastName, @emailPost, @phoneNumber, @mobilePhoneNumber, @dateOfBirth, @postIndex);
    
END



GO


